Downloads From Sage
SOP Downloads
Single Price List
See below our sample template PriceListBasicSOP.xls Note:
|
|
Price List |
|
|
|
|
|
Special Price List |
|
|
|
|
|
|
|
Product Description |
Standard Price |
Price 1 |
New Price 1 |
|
CAM LEVER ASTRA |
6.200 |
4.047 |
0.000 |
|
ASTRA FUEL PUMP |
42.900 |
41.572 |
0.000 |
|
BODY LOWER ASS ASTRA |
15.440 |
13.196 |
0.000 |
To populate this sheet, select the download option from the menu:
Excelerator will download the data onto the sheet.
See below another sample temple PriceListSingleSOP.xls.
Note:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Price List |
|
|
|
|
|
|
|
|
|
|
CUSTOMER SPECIFIC |
|
|
|
|
|
|
|
|
|
|
|
|
Product |
Customer |
Customer Name |
Product Description |
Standard Price |
Start Date |
End Date |
Price 1 |
New Price 1 |
|
461-210 |
C003 |
Eastern Motors |
ASTRA FUEL PUMP |
42.900 |
|
|
42.000 |
42.000 |
|
462-210 |
C003 |
Eastern Motors |
NOT FOUND |
42.900 |
|
|
50.000 |
50.000 |
|
563-210 |
C003 |
Eastern Motors |
NOT FOUND |
42.900 |
|
|
20.000 |
20.000 |
|
564-210 |
C003 |
Eastern Motors |
NOT FOUND |
42.900 |
|
|
54.000 |
54.000 |
|
565-210 |
C003 |
Eastern Motors |
NOT FOUND |
42.900 |
|
|
60.000 |
60.000 |
|
PENS |
JJ002 |
NOT FOUND |
NOT FOUND |
42.900 |
|
|
5.000 |
4.500 |
|
PENS |
JJ002 |
NOT FOUND |
NOT FOUND |
42.900 |
25/07/1997 |
25/08/1997 |
0.000 |
0.000 |
Multiple Price Lists
See below our sample template PriceListMultiSOPNoDates.xls. This sheet can be used to download and upload up to 2 SOP price lists at a time. It does not have promotional dates, although these can be used on multiple price lists sheets.
Note:
|
|
|
|
|
|
SE1 |
|
SE2 |
|
|
|
|
|
|
|
Normal Price List |
Amended Price List |
|
|
|
|
|
|
|
|
|
|
|
|
|
Product |
Customer |
Customer Name |
Product Description |
Standard Price |
Price 1 |
New Price 1 |
Price 2 |
New Price 2 |
|
461-115 |
|
|
CAM LEVER ASTRA |
6.200 |
17.340 |
17.340 |
6.000 |
8.000 |
|
461-210 |
|
|
ASTRA FUEL PUMP |
42.900 |
2.000 |
2.000 |
7.000 |
0.000 |
|
461-311 |
|
|
BODY LOWER ASS ASTRA |
15.440 |
187.000 |
0.000 |
8.000 |
0.000 |
|
461-415 |
|
|
CAM/LINK PHAN ASTRA |
7.000 |
|
|
9.000 |
0.000 |
|
469-101 |
|
|
FILTER COVER |
3.200 |
|
|
10.000 |
0.000 |
Downloading POP Price Lists
This is similar to downloading SOP Price Lists. See below our sample template PriceListMultiplePOP.xls. This sheet can be used to download and upload up to 2 POP price lists at a time. It has promotional dates.
Note:
|
|
|
|
|
Price List/S001 001 |
|
Price List/ Supplier |
BIKECO 003 |
|||
|
|
|
|
|
Supplier STANDARD LIST |
|
Price List 003 |
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
Product |
Product Description |
Standard Price |
Start Date |
End Date |
Price 1 |
New Price 1 |
Start Date |
End Date |
Price 2 |
New Price 2 |
|
461-115 |
CAM LEVER ASTRA |
6.200 |
|
|
3.100 |
3.300 |
|
|
11.000 |
16.000 |
|
461-115 |
CAM LEVER ASTRA |
6.200 |
01/08/2008 |
05/08/2008 |
100.000 |
0.000 |
|
|
|
|
|
461-311 |
BODY LOWER ASS ASTRA |
15.440 |
|
|
|
|
|
|
19.000 |
20.000 |
|
469-101 |
FILTER COVER |
3.200 |
|
|
1.200 |
1.200 |
|
|
|
|
|
469-102 |
SEALING GASKET |
2.200 |
|
|
0.680 |
0.695 |
|
|
|
|
|
469-103 |
FUEL FILTER |
0.600 |
|
|
0.270 |
0.290 |
|
|
|
|
Downloading SOP and POP Price Lists
It is possible to download and upload SOP and POP Price Lists from a single sheet. Please see below our sample template PriceListSOPAndPOP.xls.
|
|
|
|
|
|
|
Price List L03 |
Price List/S001 001 |
|||||
|
|
|
|
|
|
|
CUSTOMER SPECIFIC |
Supplier |
STANDARD LIST |
||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Product |
Customer |
Customer Name |
Product Description |
Standard Price |
Start Date |
End Date |
Price 1 |
New Price 1 |
Start Date |
End Date |
Price 1 |
New Price 1 |
|
461-115 |
|
|
CAM LEVER ASTRA |
6.200 |
|
|
|
|
|
|
3.100 |
3.300 |
|
461-210 |
C003 |
Eastern Motors |
ASTRA FUEL PUMP |
42.900 |
|
|
42.000 |
42.000 |
|
|
|
|
|
462-210 |
C003 |
Eastern Motors |
NOT FOUND |
42.900 |
|
|
50.000 |
50.000 |
|
|
|
|
|
469-101 |
|
|
FILTER COVER |
3.200 |
|
|
|
|
|
|
1.200 |
1.200 |
|
469-102 |
|
|
SEALING GASKET |
2.200 |
|
|
|
|
|
|
0.680 |
0.695 |
|
469-103 |
|
|
FUEL FILTER |
0.600 |
|
|
|
|
|
|
0.270 |
0.290 |